//===============================================================================
// Microsoft Architecture Strategy Team
// LitwareHR - SaaS Sample Application
//===============================================================================
// Copyright  Microsoft Corporation.  All rights reserved.
// THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY
// OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT
// LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
// FITNESS FOR A PARTICULAR PURPOSE.
//===============================================================================
// The example companies, organizations, products, domain names,
// e-mail addresses, logos, people, places, and events depicted
// herein are fictitious.  No association with any real company,
// organization, product, domain name, email address, logo, person,
// places, or events is intended or should be inferred.
//===============================================================================



using System;
using System.Collections.Generic;
using System.Text;

namespace Shp.Runtime.DataModel.Sql
{
    internal static class Constants
    {     

        #region DB

        internal static class DB
        {
            internal const string TenantDataStore = "TenantDataStore";
            internal const string TenantMetadataStore = "TenantMetadataStore";
            internal const string SqlForSelectEntityList = "SELECT * FROM [dbo].[{0}_{1}] WHERE id IN ({2})";
            internal const string DropView = "IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[{0}_{1}]')) DROP VIEW [dbo].[{0}_{1}]";
            internal const string CreateView = @"CREATE VIEW [dbo].[{0}_{1}] AS SELECT E.id, ";
        }

        #endregion
      
    }
}
